SalesMeter

Entity Definition

Logical Name : SalesMeter
Physical Name : AS_MTR_SLS

A mechanical or electronic meter that counts the monetary value or volume of blended ITEM dispensed during all FUELLING TRANSACTIONS ever.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RetailStoreID (FK)(PK) A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter ID_STR_RTL Identity integer RetailStore(PA_STR_RTL)
SalesMeterID (PK) A system-assigned unique identifier for a sales meter. ID_MTR_SLS Identity integer
UnitOfMeasureCode (FK) The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. CD_UOM Code varchar(20) UnitOfMeasure(CO_UOM)
DeviceMeterID The MeterID the FuelingPoint uses to identify this SalesMeter. Cannot use this MeterID as the Primary Key because Meters break and need to be replaced. ID_MTR_DVC IdentityAlphaNumeric varchar(20)
StatusCode A code denoting the status of the SalesMeter. Possible values include Active and InActive. SC_MTR Code2Status char(2)

Relationships

Parent Entity Verb Phrase Child Entity
UnitOfMeasure counts SalesMeter
RetailStore has SalesMeter
SalesMeter records from Nozzle
SalesMeter records SalesMeterReading

Logical Views containing SalesMeter

Logical View
Logical 20000 - Forecourt Macro View
Logical 20010 - Forecourt Fueling Point View
Logical 20040 - Forecourt History View